[dbo].[ContentWorkflowParameters]

Property	Value
Row Count	0
Created	10:31:18 AM Tuesday, March 02, 2010
Last Modified	1:17:32 PM Thursday, February 23, 2012

Property

Value

Row Count

Created

10:31:18 AM Tuesday, March 02, 2010

Last Modified

1:17:32 PM Thursday, February 23, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_ContentWorkflowParameters: DocumentVersionKey\PublishedVersion$	DocumentVersionKey	uniqueidentifier	16
$Cluster Primary Key PK_ContentWorkflowParameters: DocumentVersionKey\PublishedVersion$	PublishedVersion	bit	1
	ContentAuthorityGroupKey	uniqueidentifier	16
	OwnerGroupMemberKey	uniqueidentifier	16
	NumberOfDaysBeforeExpiration	int	4
	ExpirationDate	datetime	8
	FirstWarningSentOn	datetime	8
	SecondWarningSentOn	datetime	8
	FirstNotificationSentOn	datetime	8
	SecondNotificationSentOn	datetime	8
	AdditionalNoticeSentOn	datetime	8
	RecycleAtExpiration	bit	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_ContentWorkflowParameters: DocumentVersionKey\PublishedVersion$

DocumentVersionKey

uniqueidentifier

$Cluster Primary Key PK_ContentWorkflowParameters: DocumentVersionKey\PublishedVersion$

PublishedVersion

bit

Foreign Keys FK_ContentWorkflowParameters_ContentManagerAuthorityGroup: [dbo].[ContentManagerAuthorityGroup].ContentAuthorityGroupKey

ContentAuthorityGroupKey

uniqueidentifier

OwnerGroupMemberKey

uniqueidentifier

NumberOfDaysBeforeExpiration

int

ExpirationDate

datetime

FirstWarningSentOn

datetime

SecondWarningSentOn

datetime

FirstNotificationSentOn

datetime

SecondNotificationSentOn

datetime

AdditionalNoticeSentOn

datetime

RecycleAtExpiration

bit

	Name	Columns
$Cluster Primary Key PK_ContentWorkflowParameters: DocumentVersionKey\PublishedVersion$	PK_ContentWorkflowParameters	DocumentVersionKey, PublishedVersion
	IX_ContentWorkflowParameters_ContentAuthorityGroupKey	ContentAuthorityGroupKey
	IX_ContentWorkflowParameters_OwnerGroupMemberKey	OwnerGroupMemberKey

Name

Columns

Unique

$Cluster Primary Key PK_ContentWorkflowParameters: DocumentVersionKey\PublishedVersion$

PK_ContentWorkflowParameters

DocumentVersionKey, PublishedVersion

IX_ContentWorkflowParameters_ContentAuthorityGroupKey

ContentAuthorityGroupKey

IX_ContentWorkflowParameters_OwnerGroupMemberKey

OwnerGroupMemberKey

Name	Columns
FK_ContentWorkflowParameters_ContentManagerAuthorityGroup	ContentAuthorityGroupKey->[dbo].[ContentManagerAuthorityGroup].[GroupKey]
FK_ContentWorkflowParameters_GroupMember	OwnerGroupMemberKey->[dbo].[GroupMember].[GroupMemberKey]
FK_ContentWorkflowParameters_UniformRegistry	DocumentVersionKey->[dbo].[UniformRegistry].[UniformKey]

Name

Columns

FK_ContentWorkflowParameters_ContentManagerAuthorityGroup

ContentAuthorityGroupKey->[dbo].[ContentManagerAuthorityGroup].[GroupKey]

FK_ContentWorkflowParameters_GroupMember

OwnerGroupMemberKey->[dbo].[GroupMember].[GroupMemberKey]

FK_ContentWorkflowParameters_UniformRegistry

DocumentVersionKey->[dbo].[UniformRegistry].[UniformKey]

SQL Script

CREATE TABLE [dbo].[ContentWorkflowParameters]
(
[DocumentVersionKey] [uniqueidentifier] NOT NULL,
[PublishedVersion] [bit] NOT NULL,
[ContentAuthorityGroupKey] [uniqueidentifier] NOT NULL,
[OwnerGroupMemberKey] [uniqueidentifier] NULL,
[NumberOfDaysBeforeExpiration] [int] NULL,
[ExpirationDate] [datetime] NULL,
[FirstWarningSentOn] [datetime] NULL,
[SecondWarningSentOn] [datetime] NULL,
[FirstNotificationSentOn] [datetime] NULL,
[SecondNotificationSentOn] [datetime] NULL,
[AdditionalNoticeSentOn] [datetime] NULL,
[RecycleAtExpiration] [bit] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ContentWorkflowParameters] ADD CONSTRAINT [PK_ContentWorkflowParameters] PRIMARY KEY CLUSTERED ([DocumentVersionKey], [PublishedVersion]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContentWorkflowParameters_ContentAuthorityGroupKey] ON [dbo].[ContentWorkflowParameters] ([ContentAuthorityGroupKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ContentWorkflowParameters_OwnerGroupMemberKey] ON [dbo].[ContentWorkflowParameters] ([OwnerGroupMemberKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContentWorkflowParameters] ADD CONSTRAINT [FK_ContentWorkflowParameters_ContentManagerAuthorityGroup] FOREIGN KEY ([ContentAuthorityGroupKey]) REFERENCES [dbo].[ContentManagerAuthorityGroup] ([GroupKey])
GO
ALTER TABLE [dbo].[ContentWorkflowParameters] ADD CONSTRAINT [FK_ContentWorkflowParameters_GroupMember] FOREIGN KEY ([OwnerGroupMemberKey]) REFERENCES [dbo].[GroupMember] ([GroupMemberKey])
GO
ALTER TABLE [dbo].[ContentWorkflowParameters] ADD CONSTRAINT [FK_ContentWorkflowParameters_UniformRegistry] FOREIGN KEY ([DocumentVersionKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO